UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PLG/rPzHRnL7XcX35LKF91StbnAnYjGVFgLWYr/vGdc='
WHERE
key_id = '9ba4e8fb4d98ea7949f1c2aa4f0990f865a7812792a686f42429e92df9db196d'
AND (
token = 'PLG/rPzHRnL7XcX35LKF91StbnAnYjGVFgLWYr/vGdc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)