UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jISW21GQv+x7/knqOQXsN66rjFyQmAwZDrfg9EJjvbU=' 
WHERE 
  key_id = 'e0191cec9e73f475e5bb8f011a8025053be2657a37a637ea02d470051e0215e9' 
  AND (
    token = 'jISW21GQv+x7/knqOQXsN66rjFyQmAwZDrfg9EJjvbU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031