UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yYmEhM4DEmk7ebRQJlKufbMGh5yn/Iv5eHbfobHSvRc='
WHERE
key_id = '24597a17c22bed4583ab177a920be78ae208918045c0615f5db1bef32d71b9d1'
AND (
token = 'yYmEhM4DEmk7ebRQJlKufbMGh5yn/Iv5eHbfobHSvRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)