UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wiaWjmGsIV7B4nHv3s2WG1tEHo4503CeQK6kOiF45U0='
WHERE
key_id = '0d75d0019240f6541c716fcd80bbf47dec11ea6bf900b17fd371d49ad8cb29a0'
AND (
token = 'wiaWjmGsIV7B4nHv3s2WG1tEHo4503CeQK6kOiF45U0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)