UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6zDfOTaOFzt5Wksh4XVmZYkUtq4+aQqbd9wD149xNyM=' 
WHERE 
  key_id = '4271e966b1cd2fbc952820e72f6c2fb7e5cf06065c909b4ee0a7b15aeec3925f' 
  AND (
    token = '6zDfOTaOFzt5Wksh4XVmZYkUtq4+aQqbd9wD149xNyM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033