UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Pz6+z9+nXtvUCGuQ06L8faXGi/JQ7D+g83v8E5qRink=' 
WHERE 
  key_id = 'e0b7c098718eefb5947b201cf2f526ef4ba62b6e79123b0e579044ed8a314e91' 
  AND (
    token = 'Pz6+z9+nXtvUCGuQ06L8faXGi/JQ7D+g83v8E5qRink=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040