UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vc073kYI49WLFb4HZiXu8bVnFL4/iLWAMy80ymNfzzM='
WHERE
key_id = '1cab26bc7018033903eb4cb798bd6624222b2e88f199e2e3767440cfe65208cb'
AND (
token = 'Vc073kYI49WLFb4HZiXu8bVnFL4/iLWAMy80ymNfzzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)