UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TnNlmXOBUhhofIdU/QK8QoXrO5Z3BTuIDBiDzKiM2C4='
WHERE
key_id = 'b5e163ec47b5995ce1afb9c343c66e70438e759acba8780f4f1acb5e6056dfac'
AND (
token = 'TnNlmXOBUhhofIdU/QK8QoXrO5Z3BTuIDBiDzKiM2C4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)