UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4cJYH73PJU9YXicFCi/twZHHWfJtY3Qd9v+y8mpAGdY='
WHERE
key_id = '06cf82d2313c9bc5f51a76ad04b572ad651bf60a8197eeacb333c41c8c688184'
AND (
token = '4cJYH73PJU9YXicFCi/twZHHWfJtY3Qd9v+y8mpAGdY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)