UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NeB78Im9+s4loH+bEG6VsdZGKTinOz5mNz25eAh2+pY=' 
WHERE 
  key_id = '8ab58075c40cacac568c6410d4a850c79fa982c8257a23bd9481794fd92e9be0' 
  AND (
    token = 'NeB78Im9+s4loH+bEG6VsdZGKTinOz5mNz25eAh2+pY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025