UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xsuy9O/bUlHiZA3BZgXrOmej9sMuQVz/13ZRO0VKnAU='
WHERE
key_id = '927f41e9546b47916949531b798f16c5f27e55ea77bf56e228e6739acc8ea6c3'
AND (
token = 'Xsuy9O/bUlHiZA3BZgXrOmej9sMuQVz/13ZRO0VKnAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)