UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'It5DmiQb4kqlEbs2JkN4z+w/YzSBiE+Q2cde/bq2HlE='
WHERE
key_id = 'a8f3f915e2f25537209ee7b339c4231971b6912ecb03bc769ffc546734e38ef4'
AND (
token = 'It5DmiQb4kqlEbs2JkN4z+w/YzSBiE+Q2cde/bq2HlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)