UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XBD3EM4LoezAhvPoRII3CKXViqHlQi68RpmPArtNCI='
WHERE
key_id = 'a1d0c5c41bf2cd5fe29ef311f587a7ffb1bc0aa030f58bd3bff7c4f77d2c77a8'
AND (
token = '9XBD3EM4LoezAhvPoRII3CKXViqHlQi68RpmPArtNCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)