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