UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MicaciqY3wtI3hAs53T4BeTF4/MNNbZnW6rfGcADmH8='
WHERE
key_id = 'e4abcb857bc8cdc6ef0311d92826599112b0fcf1c3f4ac329e6090ef482a528d'
AND (
token = 'MicaciqY3wtI3hAs53T4BeTF4/MNNbZnW6rfGcADmH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)