UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NH3ZP839EWxFCYBuYFAZTdcnWMNfdBANY0pEY5nDBuU='
WHERE
key_id = 'ffa966ab4557aee433686532e6755705fdb88fd5e67b23ffbd1ca67ac30c338f'
AND (
token = 'NH3ZP839EWxFCYBuYFAZTdcnWMNfdBANY0pEY5nDBuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)