UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UW8K3VE6NtRf38SpXxHQb704JESo7EkkoaLe9XBZa9U='
WHERE
key_id = '4c60ad08e9ff6aa25f4b17c14a6d5613b19f9ed74e2d4abad8918fc8bae56e02'
AND (
token = 'UW8K3VE6NtRf38SpXxHQb704JESo7EkkoaLe9XBZa9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)