UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bAqZLuQAk1yihVewvKje3pMLcyTcFYk9GZ5uvB0dUWQ=' 
WHERE 
  key_id = '218d622da9b578bb990dadb51a117637b7a3a8de58a844067e3e9cd600010ea0' 
  AND (
    token = 'bAqZLuQAk1yihVewvKje3pMLcyTcFYk9GZ5uvB0dUWQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033