UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'j4Ue8Q769O/fwk+/NlbcRkyKtlp1n2Bi6x4vOPUjCPo=' 
WHERE 
  key_id = 'b305b3661b9c14e2e764e9f01136faf3d97ecfcd524a9bf14a3e6ac8f9936746' 
  AND (
    token = 'j4Ue8Q769O/fwk+/NlbcRkyKtlp1n2Bi6x4vOPUjCPo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026