UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yY7xhRcfc7RSIIPvQVPq7y504hZVdGfYi1FnC8HBLMU='
WHERE
key_id = '1d86f41540306dc62873315238437afa38361f8ce49401ddac53508447ce3b15'
AND (
token = 'yY7xhRcfc7RSIIPvQVPq7y504hZVdGfYi1FnC8HBLMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)