UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2CbMZb/jl/L/XKNHq5m6W491KuI8U6qSM0wL3M1aoYU=' 
WHERE 
  key_id = 'dd46f2aeeb211ac666c6a52c4893d23c85ba5bf1e422578ce5a3440d1f7d3df0' 
  AND (
    token = '2CbMZb/jl/L/XKNHq5m6W491KuI8U6qSM0wL3M1aoYU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043