UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4wVy9+OLKCahmKF7XLqw2MJB/YLHK9ZYvzZU7zue3Rg='
WHERE
key_id = 'cba341256b77633b3f69c77526c2c72a999de4470223b7d30df66de3983b07b0'
AND (
token = '4wVy9+OLKCahmKF7XLqw2MJB/YLHK9ZYvzZU7zue3Rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)