UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qIG5R9g8H8ftOENZ93R7+Bk2jCiGbUYaleGIZErUUOs='
WHERE
key_id = '33267797bed65f8cee05dfffcc8b54c6f75d8f8d29b284acd728a58002862238'
AND (
token = 'qIG5R9g8H8ftOENZ93R7+Bk2jCiGbUYaleGIZErUUOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)