UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xUHV6qS8kGxPZ8up+tAVPPZT1MD/U2I6qqgruho6eHM=' 
WHERE 
  key_id = 'da283b2abb9a9a0ddd60803c85b88bb376ab7abb8dc273991b3a6a8b841abedd' 
  AND (
    token = 'xUHV6qS8kGxPZ8up+tAVPPZT1MD/U2I6qqgruho6eHM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043