UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '96yIU0u8zJ0M9MSzc0cjI0sRMS5P5vEtBlxhOHnzk8s='
WHERE
key_id = '57047a5f037ccfb6ec65dc3050abfa836f7499a579d4dfaa80bde348b3170145'
AND (
token = '96yIU0u8zJ0M9MSzc0cjI0sRMS5P5vEtBlxhOHnzk8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)