UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tS30/4Rw5HNEWkBT7oj39YxzCzjTII0g+rnNoxtL550=' 
WHERE 
  key_id = 'ee55e92b69c15f475ecf55d042ef7ec57c9ac436b2578ba9a54c3eddcc0cb8b1' 
  AND (
    token = 'tS30/4Rw5HNEWkBT7oj39YxzCzjTII0g+rnNoxtL550=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035