UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'q6WUtEd5Q5aYoVq5/iTiP28d16TuVjL7QCoBiaCYoXc=' 
WHERE 
  key_id = '7388eebeaa38a1342f0bf1376c9cc067eb325f424e355337fd61c7265a24c76f' 
  AND (
    token = 'q6WUtEd5Q5aYoVq5/iTiP28d16TuVjL7QCoBiaCYoXc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024