UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YtZ2LC7daytJhMBjvnSpFC3mA1F0E/h4718FWE/uDxY='
WHERE
key_id = '423144427740620b37aa6a3fc3fee3ffa5955ecf2f517b7b4c07865ec65fece9'
AND (
token = 'YtZ2LC7daytJhMBjvnSpFC3mA1F0E/h4718FWE/uDxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)