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