UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '77WEA3JtvV3C0070lc4C7QmRno9N7O4yVkqVhld3Xn4=' 
WHERE 
  key_id = 'abce2d2cdc4562b155b7ba5cf5f91e1ecabf215b6c2aa28a36c27a3bdd1d684c' 
  AND (
    token = '77WEA3JtvV3C0070lc4C7QmRno9N7O4yVkqVhld3Xn4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041