UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p+7DyQJAO2xZP4Y/Yfmfd2wX6oP9RuT6PVYSkRD2msM='
WHERE
key_id = '3530b261ed1fb0bbe4ec60a2ab7f33782bd2fa8f03b3fc6f273e6c5bc70e61a8'
AND (
token = 'p+7DyQJAO2xZP4Y/Yfmfd2wX6oP9RuT6PVYSkRD2msM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)