UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c7hExXeDZ8KO/3bKyfZc53cppDdUyq38tCBZjvNyyyM='
WHERE
key_id = '6878cb221627f7eb7c60253e10b5f7e3100c58351b1d577ded8247a2757eb170'
AND (
token = 'c7hExXeDZ8KO/3bKyfZc53cppDdUyq38tCBZjvNyyyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)