UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5lg8jx45+XVAsQkTZSCCg/HQ1BDkJRcrr0AL7+fB3HE=' 
WHERE 
  key_id = '1c22ef33b8f1bd90a9f79e9de98c1d2b75f4aab59437cbe5408bc2520beb0fca' 
  AND (
    token = '5lg8jx45+XVAsQkTZSCCg/HQ1BDkJRcrr0AL7+fB3HE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036