UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lI9ZuDLyPHw9T4Pk4d9Ll1HKpXyAOd47vFbgq8imID8='
WHERE
key_id = 'c05de74f359faf2572d8861250c9a7c8ac431feac46bb837db0777cd21559d57'
AND (
token = 'lI9ZuDLyPHw9T4Pk4d9Ll1HKpXyAOd47vFbgq8imID8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)