UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oCFRBjIRTl3wiksFC7dYc/RCwodowDBAxfxxAicL2fY='
WHERE
key_id = 'dd29c4d12704b3522457670970bb56b61bb70032aec59df8ea9eed83e4eb370e'
AND (
token = 'oCFRBjIRTl3wiksFC7dYc/RCwodowDBAxfxxAicL2fY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)