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