UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'K5t6pkxYeCQd/4PCGxdz2OWMZeSCuB+zFS3eg0dlvfA=' 
WHERE 
  key_id = 'adfc41fdcb80eb6370c85f96e0cf2df08e919736cefc8f2fb03c33415c9f7be8' 
  AND (
    token = 'K5t6pkxYeCQd/4PCGxdz2OWMZeSCuB+zFS3eg0dlvfA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027