UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2KEPcaLTh88qLg0nMXtiE6Vz4F6uz8ink9kr5QI7vBY=' 
WHERE 
  key_id = 'a35d0a87fae130cea50e248ac53d2e9ea499ff0b24ceee9fe02178f2ca6871b0' 
  AND (
    token = '2KEPcaLTh88qLg0nMXtiE6Vz4F6uz8ink9kr5QI7vBY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024