UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UsIdd1HD5b8Fy+xvX8xEY9CRrRt7OCQZL08vPtbWEyk='
WHERE
key_id = 'd651ce9f446e7f293ee0a819a0535bd5a02f9692e7c23a8275cf0be1b2f1df78'
AND (
token = 'UsIdd1HD5b8Fy+xvX8xEY9CRrRt7OCQZL08vPtbWEyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)