UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TG5QBKq0yMUqp/lH9PIYFfYR3uu1TYdLt1iYBhvmcNg=' 
WHERE 
  key_id = '0c5af2d385bcd8ec78a0654b62d0bd2746ed491a69d32126366a94256cea0df7' 
  AND (
    token = 'TG5QBKq0yMUqp/lH9PIYFfYR3uu1TYdLt1iYBhvmcNg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033