UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vz7LJ3+f/rYqjmVbpdBVBEm01I59ES11FWCHiGfcMs8=' 
WHERE 
  key_id = 'aec8bb39fc1829ed134cd2eb42a7d66b1168891a0a5aa430eccf5738d9f82b14' 
  AND (
    token = 'vz7LJ3+f/rYqjmVbpdBVBEm01I59ES11FWCHiGfcMs8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022