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