UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VtcZywlC+dpIs6mV9LMJ3eFWj7EH62HQ8EDflKQzX+0='
WHERE
key_id = '7ca9382c5862a196e9787a94054010c6a4738f4ae97a1b5879253b57e113ec20'
AND (
token = 'VtcZywlC+dpIs6mV9LMJ3eFWj7EH62HQ8EDflKQzX+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)