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