UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UEMGcWf3V/h6V+F7ROMwCa+5+XnozNvOwdCZfHCwezs=' 
WHERE 
  key_id = 'd90cde9167e114dc93492d1929b72250c23d5a632b86dda8e2908d8f05ffd303' 
  AND (
    token = 'UEMGcWf3V/h6V+F7ROMwCa+5+XnozNvOwdCZfHCwezs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033